www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/khl.cpp
// khl.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "khl.h" #include "ado.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // khl dialog khl::khl(CWnd* pParent /*=NULL*/) : CDialog(khl::IDD, pParent) { //{{AFX_DATA_INIT(khl) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT } void khl::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(khl) DDX_Control(pDX, IDC_LIST1, m_list); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(khl, CDialog) //{{AFX_MSG_MAP(khl) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // khl message handlers BOOL khl::OnInitDialog() { CDialog::OnInitDialog(); m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS); m_list.SetExtendedStyle(LVS_EX_GRIDLINES); m_list.InsertColumn(0,"客户编号"); m_list.InsertColumn(1,"客户名称"); m_list.InsertColumn(2,"企业性质"); m_list.InsertColumn(3,"企业类型"); m_list.InsertColumn(4,"企业资信"); m_list.InsertColumn(5,"企业地址"); m_list.InsertColumn(6,"所属省份"); m_list.InsertColumn(7,"所属城市"); m_list.InsertColumn(8,"公司邮编"); m_list.InsertColumn(9,"法人代表"); m_list.InsertColumn(10,"开户银行"); m_list.InsertColumn(11,"银行账号"); m_list.InsertColumn(12,"纳税号"); m_list.InsertColumn(13,"客户IC卡号"); m_list.InsertColumn(14,"公司网址"); m_list.InsertColumn(15,"公司电话"); m_list.InsertColumn(16,"公司传真"); m_list.InsertColumn(17,"主要联系人"); m_list.InsertColumn(18,"联系人电话"); m_list.InsertColumn(19,"客户级别"); m_list.InsertColumn(20,"备注信息"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); m_list.SetColumnWidth(6,100); m_list.SetColumnWidth(7,100); m_list.SetColumnWidth(8,100); m_list.SetColumnWidth(9,100); m_list.SetColumnWidth(10,100); m_list.SetColumnWidth(11,100); m_list.SetColumnWidth(12,100); m_list.SetColumnWidth(13,100); m_list.SetColumnWidth(14,100); m_list.SetColumnWidth(15,100); m_list.SetColumnWidth(16,100); m_list.SetColumnWidth(17,100); m_list.SetColumnWidth(18,100); m_list.SetColumnWidth(19,100); m_list.SetColumnWidth(20,100); m_list.EnableAutomation(); this->loadlist(); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void khl::loadlist() { ado rst; rst.Open("select * from tb_khxx",adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khxx_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khxx_mc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khxx_qyxz")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khxx_qylx")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khxx_qyzx")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khxx_qydz")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khxx_szsf")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khxx_szcs")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("khxx_gsyb")); m_list.SetItemText(ii-1,9,rst.GetFieldValue("khxx_frdb")); m_list.SetItemText(ii-1,10,rst.GetFieldValue("khxx_khyh")); m_list.SetItemText(ii-1,11,rst.GetFieldValue("khxx_yhzh")); m_list.SetItemText(ii-1,12,rst.GetFieldValue("khxx_nsh")); m_list.SetItemText(ii-1,13,rst.GetFieldValue("khxx_ICcard")); m_list.SetItemText(ii-1,14,rst.GetFieldValue("khxx_gswz")); m_list.SetItemText(ii-1,15,rst.GetFieldValue("khxx_gsdh")); m_list.SetItemText(ii-1,16,rst.GetFieldValue("khxx_gscz")); m_list.SetItemText(ii-1,17,rst.GetFieldValue("khxx_lxr")); m_list.SetItemText(ii-1,18,rst.GetFieldValue("khxx_lxrdh")); m_list.SetItemText(ii-1,19,rst.GetFieldValue("khxx_khjb")); m_list.SetItemText(ii-1,20,rst.GetFieldValue("khxx_bz")); rst.Move(ii); } rst.close(); }